Original article: http://blogs.msdn.com/ B /askjay/archive/2010/02/05/how-can-i-create-a-dump-of-sql-server.aspx
You can create a memory dump of the SQL Server process space in several ways. there are using external tools that can help you
Debug SQL Server (i) How to generate a dump fileDebug SQL Server (ii) Debugging environment settings for SQL Server using WinDbgDebug SQL Server (iii) Some commands for debugging SQL Server using WinDbgWe know that there are two main ways of
https://blogs.msdn.microsoft.com/askjay/2009/12/29/basic-debugging-concepts-and-setup/You can create a memory dump of the SQL Server process space in several ways. There is many external tools that can help you accomplish this such as Userdump.exe,
Debug SQLSERVER (1) generate dump file debugging SQLSERVER (2) use Windbg to debug SQLSERVER's Environment Settings debugging SQLSERVER (3) using Windbg to debug some SQL Server commands, we know that there are two main ways to debug the program:
Oracle Common Dump command
Memory Dumps
1). Global Area
ALTER session SET The EVENTS ' immediatetrace name Global_area level n ';
1 contains PGA 2 contains SGA 4 contains UGA 8 contains indrect memory
2). Library Cache
ALTER session SET The EVENTS '
One, Oracle trace fileThere are three types of Oracle trace files, a background alarm log file that records the activity of the background process during startup, shutdown, and operation of the database, such as tablespace creation, rollback segment
One, Oracle trace FileOracle trace files are grouped into three categories:
One is the background alarm log file that records the activity of the background process during startup, shutdown, and running of the database , such as table space
I,OracleTracking FileThere are three types of Oracle tracking files:
One is the background alarm log file, which recordsDatabaseActivities of background processes during startup, shutdown, and running, such as creating tablespaces, creating
Introduction 1. What is WinDbg
WinDbg is a very good source-level (Source-level) debugging tool released by Microsoft, which can be used for kernel mode debugging and user-mode debugging, as well as debugging dump files.
WinDbg
Dump files are often encountered at work. Sometimes a dump is obtained, but more information is not provided, which may cause problems during import. If a user
Dump files are often encountered at work. Sometimes a dump is obtained, but more
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.